How to: Get a combo box or list box to default to the first item in the list.
Solution:
In the Form Design view, use the 'Default Value' property box in the property sheet of the form to get a combo box or list box to default to the first item in the list.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the desired combo box or list box on the form.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Data' tab.
8) Click on the 'Default Value' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Type the following command to set the default value:
=[<MyCombo>].[ItemData](0)
(where <MyCombo> is the name of the control).
11) Select the 'File' menu and select 'Save' to save the form.
